package com.tnr.scgcxx.dao.info;

import java.util.List;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.dq.base.page.PageParam;

import com.tnr.scgcxx.dto.StandardDto;
import com.tnr.scgcxx.model.Standard;

public interface StandardDao {
	
	@Select("select standard_id,standard_name,standard_remark,standard_status from info_standard")
	public List<Standard> findAllStandards();
	
	//@Select("select standard_id,standard_name,standard_remark,standard_status from info_standard")
	public List<Standard> findStandardsPage(PageParam pageParam);

	@Insert("insert into info_standard(standard_id,standard_name,standard_remark,standard_status) values(#{standard_id},#{standard_name},#{standard_remark},#{standard_status})")
	public int insertStandard(StandardDto dto);

	
	public int updateStandard(StandardDto dto);

	
	@Select("select standard_id,standard_name,standard_remark,standard_status from info_standard where standard_id=#{standard_id}")
	public Standard findStandardbyId(String standard_id);

	public int deleteStandardByIds(Integer... standard_ids);

}
